SQL INNER JOIN

            

INNER JOIN Keyword:

Also as simple join.we can use join instead of inner join

The INNER JOIN keyword selects records that have matching values in both tables.

     SELECT column_name(s) FROM table1
     JOIN table2 ON table1.column_name = table2.column_name;

Example:

SELECT Orders.OrderID, Customers.CustomerName FROM Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;

Note: The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns. If there are records in the "Orders" table that do not have matches in "Customers", these orders will not be shown!